SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_AddFileLink]
    (
      @JOL_File_Title VARCHAR(100),
      @JOL_File_Type VARCHAR(50),
      @JOL_File_FileUrl VARCHAR(255),
      @JOL_File_Remark NTEXT,
      @JOL_File_AddTime DATETIME,
      @JOL_File_AddUser VARCHAR(50)
    )
AS 
    INSERT  INTO dbo.JOL_FileLink
            (
              JOL_File_Title,
              JOL_File_Type,
              JOL_File_FileUrl,
              JOL_File_Remark,
              JOL_File_AddTime,
              JOL_File_AddUser,
              JOL_File_UpdateTime,
              JOL_File_UpdateUser
            )
    VALUES  (
              @JOL_File_Title, -- JOL_File_Title - varchar(100)
              @JOL_File_Type, -- JOL_File_Type - varchar(50)
              @JOL_File_FileUrl, -- JOL_File_FileUrl - varchar(255)
              @JOL_File_Remark, -- JOL_File_Remark - ntext
              GETDATE(), -- JOL_File_AddTime - datetime
              @JOL_File_AddUser, -- JOL_File_AddUser - varchar(50)
              NULL, -- JOL_File_UpdateTime - datetime
              NULL  -- JOL_File_UpdateUser - varchar(50)
            )
GO
